Flexible queries in relational databases

نویسندگان

  • Patrick Bosc
  • Didier Dubois
  • Olivier Pivert
  • Henri Prade
چکیده

Allowing for flexible queries enables database users to express preferences inside minimal requirements, and, if necessary, priorities inside compound queries. In other words, clear-cut properties can be refined by ordering the interpretations compatible with them, according to user's preferences. Often the representation of these preferences can be viewed as modelling linguistic-like terms in requests. In this paper, the theoretical issues raised by the introduction of flexible queries are studied in the case of the division operator, in the framework of fuzzy sets and possibility theory. The notion of division is well-known in the context of regular relations and the extension of this operation to fuzzy relations (induced by the flexible queries) is investigated. Several types of extended divisions can be envisaged, depending on the meaning of the grades attached to the tuples of the fuzzy relations (degree of fulfillment of gradual properties, level of importance of components in a query, or uncertainty pervading data). We focus on the first two meanings which are associated with different multiple-valued logic implications and we examine their properties and their expression in the framework of an extended SQL-like language where no specific construct for the division is available.

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Apply Uncertainty in Document-Oriented Database (MongoDB) Using F-XML

As moving to big data world where data is increasing in unstructured way with high velocity, there is a need of data-store to store this bundle amount of data. Traditionally, relational databases are used which are now not compatible to handle this large amount of data, so it is needed to move on to non-relational data-stores. In the current study, we have proposed an extension of the Mongo...

متن کامل

Apply Uncertainty in Document-Oriented Database (MongoDB) Using F-XML

As moving to big data world where data is increasing in unstructured way with high velocity, there is a need of data-store to store this bundle amount of data. Traditionally, relational databases are used which are now not compatible to handle this large amount of data, so it is needed to move on to non-relational data-stores. In the current study, we have proposed an extension of the Mongo...

متن کامل

Relational Databases Query Optimization using Hybrid Evolutionary Algorithm

Optimizing the database queries is one of hard research problems. Exhaustive search techniques like dynamic programming is suitable for queries with a few relations, but by increasing the number of relations in query, much use of memory and processing is needed, and the use of these methods is not suitable, so we have to use random and evolutionary methods. The use of evolutionary methods, beca...

متن کامل

Introducing the aggregate "count" into flexible queries

Flexible querying aims at expressing preferences inside queries instead of strict requirements. We consider ordinary relational databases and flexible querying calling on fuzzy sets. The topic of this paper is to define new types of flexible conditions : the ones involving the count operator. The main difficulty is to handle cardinalities of fuzzy sets. keywords : databases, flexible querying, ...

متن کامل

How to Achieve Fuzzy Relational Databases Managing Fuzzy Data and Metadata

Fuzzy relational databases have been introduced to deal with uncertain or incomplete information demonstrating the efficiency of processing fuzzy queries. For these reasons, many organizations aim to integrate flexible querying to handle imprecise data or to use fuzzy data mining tools, minimizing the transformation costs. The best solution is to offer a smooth migration towards this technology...

متن کامل

Flexible Retrieval of X-Ray Images Based on Shape Descriptors Using a Fuzzy Object-Relational Database

This paper presents a novel approach for medical image storage using a Fuzzy Object-Relational Database Management System (FORDBMS). The system stores medical images along with a set of parameters describing their content. Flexible queries can be performed over these parameters to retrieve images matching visually. To illustrate the capabilities of the FORDBMS, parameter curves are obtained fro...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 1997